You cannot mention multiple column names with commas using ADD COLUMN . You need to mention ADD COLUMN every time you define a new column. ... <看更多>

Find if the column exists using the SQL below: SELECT column_name FROM INFORMATION_SCHEMA . COLUMNS WHERE TABLE_SCHEMA =[Database Name] AND TABLE_NAME =[Table ... ... <看更多>